<?php

function removeShift($authUser, $authUserPass, $roleID, $dateID, $empID)
{
      if (checkAuthorization($authUser, $authUserPass) != true){
	     return array(ErrorCode::authFailRead);	
      }

      $conn=mysql_connect("127.0.0.1","root","","paradigmShift_DEV");
      if(!$conn)
      {
           die('Could not connect: ' . mysql_error());
         return array(ErrorCode::sysError);
      }
      $sql = "DELETE FROM roleDate WHERE roleID='$roleID' AND dateID='$dateID' AND empID='$empID'";
      if (mysql_query($conn, $sql)){
        mysql_close($conn);
       return array(ErrorCode::SuccessDelete);
      } else {
            mysql_close($conn);
            return array(ErrorCode::failDelete);
      }
}

?>